Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	17773
Missing cells	33252
Missing cells (%)	13.4%
Duplicate rows	38
Duplicate rows (%)	0.2%
Total size in memory	2.5 MiB
Average record size in memory	149.7 B

Variable types

Numeric	13
Categorical	1

Alerts

Dataset has 38 (0.2%) duplicate rows	Duplicates
`Minimum Temperature` is highly overall correlated with `Maximum Temperature` and 5 other fields	High correlation
`Maximum Temperature` is highly overall correlated with `Minimum Temperature` and 5 other fields	High correlation
`Temperature` is highly overall correlated with `Minimum Temperature` and 5 other fields	High correlation
`Dew Point` is highly overall correlated with `Minimum Temperature` and 4 other fields	High correlation
`Relative Humidity` is highly overall correlated with `Minimum Temperature` and 3 other fields	High correlation
`Wind Chill` is highly overall correlated with `Minimum Temperature` and 4 other fields	High correlation
`Snow Depth` is highly overall correlated with `Minimum Temperature` and 5 other fields	High correlation
`Visibility` is highly overall correlated with `Relative Humidity`	High correlation
`Sea Level Pressure` is highly overall correlated with `Snow Depth`	High correlation
`Wind Chill` has 10051 (56.6%) missing values	Missing
`Snow Depth` has 6781 (38.2%) missing values	Missing
`Visibility` has 1384 (7.8%) missing values	Missing
`Cloud Cover` has 14193 (79.9%) missing values	Missing
`Precipitation` has 13849 (77.9%) zeros	Zeros
`Snow Depth` has 9943 (55.9%) zeros	Zeros
`y` has 8059 (45.3%) zeros	Zeros

Reproduction

Analysis started	2022-12-18 19:55:18.566615
Analysis finished	2022-12-18 19:55:35.963550
Duration	17.4 seconds
Software version	pandas-profiling vv3.5.0
Download configuration	config.json

Minimum Temperature
Real number (ℝ)

Distinct	446
Distinct (%)	2.5%
Missing	48
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.393817

Minimum	-13.2
Maximum	38.2
Zeros	26
Zeros (%)	0.1%
Negative	853
Negative (%)	4.8%
Memory size	277.7 KiB

Quantile statistics

Minimum	-13.2
5-th percentile	0.1
Q1	4.9
median	10
Q3	15.6
95-th percentile	22.5
Maximum	38.2
Range	51.4
Interquartile range (IQR)	10.7

Descriptive statistics

Standard deviation	7.1329548
Coefficient of variation (CV)	0.68626906
Kurtosis	-0.24037381
Mean	10.393817
Median Absolute Deviation (MAD)	5.3
Skewness	0.21849668
Sum	184230.4
Variance	50.879044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.1	113	0.6%
6.4	107	0.6%
3.1	106	0.6%
9.1	106	0.6%
11.9	105	0.6%
9.2	104	0.6%
8.4	104	0.6%
9.6	101	0.6%
8	100	0.6%
13.4	100	0.6%
Other values (436)	16679	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.2	1	< 0.1%
-12.8	2	< 0.1%
-12.5	1	< 0.1%
-12.4	1	< 0.1%
-12.1	1	< 0.1%
-11.7	1	< 0.1%
-11.6	2	< 0.1%
-11.4	1	< 0.1%
-11.3	1	< 0.1%
-11.2	1	< 0.1%

Value	Count	Frequency (%)
38.2	1	< 0.1%
37.9	1	< 0.1%
37.1	1	< 0.1%
35.3	1	< 0.1%
35.1	1	< 0.1%
34.9	1	< 0.1%
34.5	1	< 0.1%
34	2	< 0.1%
33.9	1	< 0.1%
33.7	2	< 0.1%

Maximum Temperature
Real number (ℝ)

Distinct	446
Distinct (%)	2.5%
Missing	48
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.393817

Minimum	-13.2
Maximum	38.2
Zeros	26
Zeros (%)	0.1%
Negative	853
Negative (%)	4.8%
Memory size	277.7 KiB

Quantile statistics

Minimum	-13.2
5-th percentile	0.1
Q1	4.9
median	10
Q3	15.6
95-th percentile	22.5
Maximum	38.2
Range	51.4
Interquartile range (IQR)	10.7

Descriptive statistics

Standard deviation	7.1329548
Coefficient of variation (CV)	0.68626906
Kurtosis	-0.24037381
Mean	10.393817
Median Absolute Deviation (MAD)	5.3
Skewness	0.21849668
Sum	184230.4
Variance	50.879044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.1	113	0.6%
6.4	107	0.6%
3.1	106	0.6%
9.1	106	0.6%
11.9	105	0.6%
9.2	104	0.6%
8.4	104	0.6%
9.6	101	0.6%
8	100	0.6%
13.4	100	0.6%
Other values (436)	16679	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.2	1	< 0.1%
-12.8	2	< 0.1%
-12.5	1	< 0.1%
-12.4	1	< 0.1%
-12.1	1	< 0.1%
-11.7	1	< 0.1%
-11.6	2	< 0.1%
-11.4	1	< 0.1%
-11.3	1	< 0.1%
-11.2	1	< 0.1%

Value	Count	Frequency (%)
38.2	1	< 0.1%
37.9	1	< 0.1%
37.1	1	< 0.1%
35.3	1	< 0.1%
35.1	1	< 0.1%
34.9	1	< 0.1%
34.5	1	< 0.1%
34	2	< 0.1%
33.9	1	< 0.1%
33.7	2	< 0.1%

Temperature
Real number (ℝ)

Distinct	446
Distinct (%)	2.5%
Missing	48
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	10.393817

Minimum	-13.2
Maximum	38.2
Zeros	26
Zeros (%)	0.1%
Negative	853
Negative (%)	4.8%
Memory size	277.7 KiB

Quantile statistics

Minimum	-13.2
5-th percentile	0.1
Q1	4.9
median	10
Q3	15.6
95-th percentile	22.5
Maximum	38.2
Range	51.4
Interquartile range (IQR)	10.7

Descriptive statistics

Standard deviation	7.1329548
Coefficient of variation (CV)	0.68626906
Kurtosis	-0.24037381
Mean	10.393817
Median Absolute Deviation (MAD)	5.3
Skewness	0.21849668
Sum	184230.4
Variance	50.879044
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.1	113	0.6%
6.4	107	0.6%
3.1	106	0.6%
9.1	106	0.6%
11.9	105	0.6%
9.2	104	0.6%
8.4	104	0.6%
9.6	101	0.6%
8	100	0.6%
13.4	100	0.6%
Other values (436)	16679	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.2	1	< 0.1%
-12.8	2	< 0.1%
-12.5	1	< 0.1%
-12.4	1	< 0.1%
-12.1	1	< 0.1%
-11.7	1	< 0.1%
-11.6	2	< 0.1%
-11.4	1	< 0.1%
-11.3	1	< 0.1%
-11.2	1	< 0.1%

Value	Count	Frequency (%)
38.2	1	< 0.1%
37.9	1	< 0.1%
37.1	1	< 0.1%
35.3	1	< 0.1%
35.1	1	< 0.1%
34.9	1	< 0.1%
34.5	1	< 0.1%
34	2	< 0.1%
33.9	1	< 0.1%
33.7	2	< 0.1%

Dew Point
Real number (ℝ)

Distinct	345
Distinct (%)	2.0%
Missing	120
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	6.4477029

Minimum	-14.6
Maximum	21
Zeros	112
Zeros (%)	0.6%
Negative	2335
Negative (%)	13.1%
Memory size	277.7 KiB

Quantile statistics

Minimum	-14.6
5-th percentile	-3.5
Q1	2.1
median	6.8
Q3	10.9
95-th percentile	15.7
Maximum	21
Range	35.6
Interquartile range (IQR)	8.8

Descriptive statistics

Standard deviation	6.0195496
Coefficient of variation (CV)	0.93359599
Kurtosis	-0.24269251
Mean	6.4477029
Median Absolute Deviation (MAD)	4.5
Skewness	-0.29686343
Sum	113821.3
Variance	36.234977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	139	0.8%
1.6	128	0.7%
9.5	126	0.7%
2.8	125	0.7%
10	122	0.7%
8.2	119	0.7%
9.8	118	0.7%
9.6	117	0.7%
8.9	115	0.6%
9.7	115	0.6%
Other values (335)	16429	92.4%
(Missing)	120	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-14.6	1	< 0.1%
-14.1	1	< 0.1%
-14	1	< 0.1%
-13.9	2	< 0.1%
-13.8	1	< 0.1%
-13.5	1	< 0.1%
-13.3	2	< 0.1%
-13.2	2	< 0.1%
-13.1	1	< 0.1%
-12.9	6	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20.9	1	< 0.1%
20.8	1	< 0.1%
20.6	1	< 0.1%
20.4	2	< 0.1%
20.2	5	< 0.1%
20.1	2	< 0.1%
20	3	< 0.1%
19.9	1	< 0.1%
19.8	3	< 0.1%

Relative Humidity
Real number (ℝ)

Distinct	5424
Distinct (%)	30.7%
Missing	120
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	78.605042

Minimum	18.7
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	18.7
5-th percentile	46.47
Q1	68.64
median	82.93
Q3	91.59
95-th percentile	97.12
Maximum	100
Range	81.3
Interquartile range (IQR)	22.95

Descriptive statistics

Standard deviation	16.060288
Coefficient of variation (CV)	0.20431626
Kurtosis	0.032139079
Mean	78.605042
Median Absolute Deviation (MAD)	10.19
Skewness	-0.90235993
Sum	1387614.8
Variance	257.93284
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93.91	16	0.1%
93.1	15	0.1%
92.78	15	0.1%
94.59	15	0.1%
95.12	14	0.1%
93.46	13	0.1%
91.87	13	0.1%
94.89	13	0.1%
93.57	13	0.1%
95.62	13	0.1%
Other values (5414)	17513	98.5%
(Missing)	120	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.7	1	< 0.1%
19.35	1	< 0.1%
21.9	1	< 0.1%
21.99	1	< 0.1%
22.38	1	< 0.1%
23.31	1	< 0.1%
23.41	1	< 0.1%
24.26	1	< 0.1%
24.27	1	< 0.1%
25.33	1	< 0.1%

Value	Count	Frequency (%)
100	12	0.1%
99.97	6	< 0.1%
99.96	2	< 0.1%
99.95	2	< 0.1%
99.93	2	< 0.1%
99.92	1	< 0.1%
99.89	3	< 0.1%
99.88	1	< 0.1%
99.87	1	< 0.1%
99.85	1	< 0.1%

Wind Speed
Real number (ℝ)

Distinct	453
Distinct (%)	2.6%
Missing	145
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	13.894424

Minimum	0.1
Maximum	55
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	0.1
5-th percentile	3
Q1	8.2
median	12.8
Q3	18.4
95-th percentile	28.6
Maximum	55
Range	54.9
Interquartile range (IQR)	10.2

Descriptive statistics

Standard deviation	7.8205459
Coefficient of variation (CV)	0.56285501
Kurtosis	0.91121169
Mean	13.894424
Median Absolute Deviation (MAD)	5
Skewness	0.83418643
Sum	244930.9
Variance	61.160938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.6	119	0.7%
14.4	115	0.6%
13.2	114	0.6%
13.6	113	0.6%
11.9	112	0.6%
11.6	112	0.6%
11.8	111	0.6%
10.4	110	0.6%
11.2	110	0.6%
13.8	110	0.6%
Other values (443)	16502	92.8%
(Missing)	145	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	3	< 0.1%
0.2	9	0.1%
0.3	2	< 0.1%
0.4	12	0.1%
0.5	13	0.1%
0.6	8	< 0.1%
0.7	8	< 0.1%
0.8	13	0.1%
0.9	8	< 0.1%
1	14	0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
53.9	1	< 0.1%
53.3	1	< 0.1%
53	2	< 0.1%
52.9	2	< 0.1%
51.2	1	< 0.1%
50.2	1	< 0.1%
50.1	1	< 0.1%
50	1	< 0.1%
49.2	1	< 0.1%

Wind Direction
Real number (ℝ)

Distinct	353
Distinct (%)	2.0%
Missing	145
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	203.2213

Minimum	1
Maximum	360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	1
5-th percentile	44
Q1	131
median	224
Q3	279
95-th percentile	324
Maximum	360
Range	359
Interquartile range (IQR)	148

Descriptive statistics

Standard deviation	90.198712
Coefficient of variation (CV)	0.44384478
Kurtosis	-0.90615066
Mean	203.2213
Median Absolute Deviation (MAD)	67
Skewness	-0.44029223
Sum	3582385
Variance	8135.8077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
230	347	2.0%
229	342	1.9%
290	314	1.8%
220	313	1.8%
239	284	1.6%
250	267	1.5%
300	252	1.4%
240	226	1.3%
260	225	1.3%
219	219	1.2%
Other values (343)	14839	83.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	0.1%
2	4	< 0.1%
3	21	0.1%
4	20	0.1%
5	6	< 0.1%
6	18	0.1%
7	22	0.1%
8	4	< 0.1%
9	21	0.1%
10	34	0.2%

Value	Count	Frequency (%)
360	32	0.2%
359	22	0.1%
357	13	0.1%
356	16	0.1%
355	14	0.1%
354	7	< 0.1%
353	26	0.1%
352	5	< 0.1%
351	23	0.1%
350	35	0.2%

Wind Chill
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	237
Distinct (%)	3.1%
Missing	10051
Missing (%)	56.6%
Infinite	0
Infinite (%)	0.0%
Mean	1.6888889

Minimum	-15.5
Maximum	9.7
Zeros	44
Zeros (%)	0.2%
Negative	2492
Negative (%)	14.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	-15.5
5-th percentile	-5.1
Q1	-1.1
median	1.9
Q3	4.9
95-th percentile	7.5
Maximum	9.7
Range	25.2
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.123516
Coefficient of variation (CV)	2.4415555
Kurtosis	0.48745001
Mean	1.6888889
Median Absolute Deviation (MAD)	3
Skewness	-0.61871089
Sum	13041.6
Variance	17.003384
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.2	86	0.5%
2.1	85	0.5%
0.8	85	0.5%
1.4	85	0.5%
2	81	0.5%
3.5	79	0.4%
1.9	79	0.4%
1	78	0.4%
-2.3	76	0.4%
6.7	74	0.4%
Other values (227)	6914	38.9%
(Missing)	10051	56.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-15.5	1	< 0.1%
-15.1	1	< 0.1%
-15	1	< 0.1%
-14.9	1	< 0.1%
-14.4	2	< 0.1%
-14.2	1	< 0.1%
-14	1	< 0.1%
-13.9	1	< 0.1%
-13.7	1	< 0.1%
-13.5	1	< 0.1%

Value	Count	Frequency (%)
9.7	1	< 0.1%
9.5	1	< 0.1%
9.3	2	< 0.1%
9.2	5	< 0.1%
9.1	8	< 0.1%
9	7	< 0.1%
8.9	11	0.1%
8.8	15	0.1%
8.7	11	0.1%
8.6	15	0.1%

Precipitation
Real number (ℝ)

Distinct	298
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.083767513

Minimum	0
Maximum	9.02
Zeros	13849
Zeros (%)	77.9%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.47
Maximum	9.02
Range	9.02
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.35540161
Coefficient of variation (CV)	4.2427141
Kurtosis	104.28442
Mean	0.083767513
Median Absolute Deviation (MAD)	0
Skewness	8.36545
Sum	1488.8
Variance	0.1263103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13849	77.9%
0.01	602	3.4%
0.02	270	1.5%
0.05	197	1.1%
0.03	194	1.1%
0.04	143	0.8%
0.06	122	0.7%
0.08	105	0.6%
0.07	94	0.5%
0.09	79	0.4%
Other values (288)	2118	11.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13849	77.9%
0.01	602	3.4%
0.02	270	1.5%
0.03	194	1.1%
0.04	143	0.8%
0.05	197	1.1%
0.06	122	0.7%
0.07	94	0.5%
0.08	105	0.6%
0.09	79	0.4%

Value	Count	Frequency (%)
9.02	1	< 0.1%
7.87	1	< 0.1%
7.54	1	< 0.1%
5.77	1	< 0.1%
5.73	1	< 0.1%
5.3	1	< 0.1%
5.18	1	< 0.1%
5.01	1	< 0.1%
4.99	1	< 0.1%
4.96	1	< 0.1%

Snow Depth
Real number (ℝ)

HIGH CORRELATION
MISSING
ZEROS

Distinct	378
Distinct (%)	3.4%
Missing	6781
Missing (%)	38.2%
Infinite	0
Infinite (%)	0.0%
Mean	0.17686226

Minimum	0
Maximum	6.37
Zeros	9943
Zeros (%)	55.9%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6.37
Range	6.37
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.72921681
Coefficient of variation (CV)	4.1230774
Kurtosis	28.565441
Mean	0.17686226
Median Absolute Deviation (MAD)	0
Skewness	5.1128458
Sum	1944.07
Variance	0.53175715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9943	55.9%
3	52	0.3%
2	50	0.3%
1	35	0.2%
0.54	18	0.1%
0.25	17	0.1%
0.33	17	0.1%
0.83	17	0.1%
0.79	17	0.1%
0.67	17	0.1%
Other values (368)	809	4.6%
(Missing)	6781	38.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9943	55.9%
0.04	14	0.1%
0.05	2	< 0.1%
0.08	15	0.1%
0.09	1	< 0.1%
0.1	2	< 0.1%
0.13	14	0.1%
0.15	3	< 0.1%
0.17	15	0.1%
0.18	2	< 0.1%

Value	Count	Frequency (%)
6.37	1	< 0.1%
6.35	1	< 0.1%
6.33	1	< 0.1%
6.3	1	< 0.1%
6.28	2	< 0.1%
6.26	1	< 0.1%
6.24	1	< 0.1%
6.22	1	< 0.1%
6.2	1	< 0.1%
6.18	1	< 0.1%

Visibility
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	481
Distinct (%)	2.9%
Missing	1384
Missing (%)	7.8%
Infinite	0
Infinite (%)	0.0%
Mean	27.009323

Minimum	0
Maximum	50
Zeros	103
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	0
5-th percentile	4.6
Q1	13.5
median	28.5
Q3	40
95-th percentile	50
Maximum	50
Range	50
Interquartile range (IQR)	26.5

Descriptive statistics

Standard deviation	14.738858
Coefficient of variation (CV)	0.5456952
Kurtosis	-1.2637
Mean	27.009323
Median Absolute Deviation (MAD)	12.5
Skewness	-0.11118611
Sum	442655.8
Variance	217.23394
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50	821	4.6%
40	698	3.9%
45	616	3.5%
30	173	1.0%
35	165	0.9%
41	125	0.7%
5	111	0.6%
25	105	0.6%
0	103	0.6%
40.7	98	0.6%
Other values (471)	13374	75.2%
(Missing)	1384	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	103	0.6%
0.1	13	0.1%
0.3	1	< 0.1%
0.7	1	< 0.1%
0.9	94	0.5%
1	45	0.3%
1.1	6	< 0.1%
1.3	4	< 0.1%
1.4	3	< 0.1%
1.6	2	< 0.1%

Value	Count	Frequency (%)
50	821	4.6%
49.9	37	0.2%
49.7	39	0.2%
49.6	36	0.2%
49.4	28	0.2%
49.3	35	0.2%
49.1	25	0.1%
49	91	0.5%
48.9	1	< 0.1%
48.8	13	0.1%

Cloud Cover
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	14193
Missing (%)	79.9%
Memory size	904.4 KiB

0.0	2073
11.1	740
13.0	712
1.9	55

Length

Max length	4
Median length	3
Mean length	3.4055866
Min length	3

Characters and Unicode

Total characters	12192
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	11.1
2nd row	13.0
3rd row	13.0
4th row	13.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	2073	11.7%
11.1	740	4.2%
13.0	712	4.0%
1.9	55	0.3%
(Missing)	14193	79.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.0	2073	57.9%
11.1	740	20.7%
13.0	712	19.9%
1.9	55	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	4858	39.8%
.	3580	29.4%
1	2987	24.5%
3	712	5.8%
9	55	0.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	8612	70.6%
Other Punctuation	3580	29.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	4858	56.4%
1	2987	34.7%
3	712	8.3%
9	55	0.6%

Other Punctuation

Value	Count	Frequency (%)
.	3580	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	12192	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	4858	39.8%
.	3580	29.4%
1	2987	24.5%
3	712	5.8%
9	55	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12192	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	4858	39.8%
.	3580	29.4%
1	2987	24.5%
3	712	5.8%
9	55	0.5%

Sea Level Pressure
Real number (ℝ)

Distinct	644
Distinct (%)	3.7%
Missing	169
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	1015.7098

Minimum	977.6
Maximum	1048.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	277.7 KiB

Quantile statistics

Minimum	977.6
5-th percentile	997.9
Q1	1009.6
median	1016.8
Q3	1022.1
95-th percentile	1030.8
Maximum	1048.2
Range	70.6
Interquartile range (IQR)	12.5

Descriptive statistics

Standard deviation	10.043681
Coefficient of variation (CV)	0.0098883378
Kurtosis	0.63333519
Mean	1015.7098
Median Absolute Deviation (MAD)	6.1
Skewness	-0.43952496
Sum	17880554
Variance	100.87553
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1019.1	109	0.6%
1019.9	108	0.6%
1019.6	104	0.6%
1017.8	101	0.6%
1018.4	100	0.6%
1021.4	99	0.6%
1018.5	99	0.6%
1018.9	98	0.6%
1019.3	98	0.6%
1019.2	97	0.5%
Other values (634)	16591	93.3%
(Missing)	169	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
977.6	1	< 0.1%
977.7	2	< 0.1%
977.8	1	< 0.1%
977.9	1	< 0.1%
978.1	2	< 0.1%
978.3	1	< 0.1%
978.4	1	< 0.1%
978.5	1	< 0.1%
978.7	1	< 0.1%
978.9	3	< 0.1%

Value	Count	Frequency (%)
1048.2	1	< 0.1%
1048.1	1	< 0.1%
1048	2	< 0.1%
1047.9	1	< 0.1%
1047.8	4	< 0.1%
1047.7	2	< 0.1%
1047.6	2	< 0.1%
1047.2	2	< 0.1%
1046.6	1	< 0.1%
1046.5	1	< 0.1%

y
Real number (ℝ)

Distinct	199
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0010127722

Minimum	-100
Maximum	100
Zeros	8059
Zeros (%)	45.3%
Negative	4846
Negative (%)	27.3%
Memory size	277.7 KiB

Quantile statistics

Minimum	-100
5-th percentile	-17
Q1	-2
median	0
Q3	2
95-th percentile	17
Maximum	100
Range	200
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	17.471133
Coefficient of variation (CV)	17250.803
Kurtosis	16.075643
Mean	0.0010127722
Median Absolute Deviation (MAD)	2
Skewness	0.016380756
Sum	18
Variance	305.24049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8059	45.3%
3	598	3.4%
-3	592	3.3%
-4	529	3.0%
4	503	2.8%
-5	472	2.7%
2	469	2.6%
5	460	2.6%
-2	437	2.5%
6	373	2.1%
Other values (189)	5281	29.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-100	88	0.5%
-99	1	< 0.1%
-98	3	< 0.1%
-97	1	< 0.1%
-96	1	< 0.1%
-95	2	< 0.1%
-94	1	< 0.1%
-93	2	< 0.1%
-92	2	< 0.1%
-91	1	< 0.1%

Value	Count	Frequency (%)
100	92	0.5%
99	2	< 0.1%
98	3	< 0.1%
96	3	< 0.1%
95	2	< 0.1%
93	2	< 0.1%
92	3	< 0.1%
91	3	< 0.1%
90	2	< 0.1%
89	2	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Minimum Temperature	Maximum Temperature	Temperature	Dew Point	Relative Humidity	Wind Speed	Wind Direction	Wind Chill	Visibility	Cloud Cover	Sea Level Pressure	y
2020-10-01 00:00:00	12.3	12.3	12.3	11.1	92.43	8.8	120.0	NaN	17.7	11.1	1012.7	0
2020-10-01 01:00:00	11.8	11.8	11.8	10.6	92.79	10.1	106.0	NaN	15.1	13.0	1012.1	0
2020-10-01 02:00:00	11.2	11.2	11.2	10.2	93.60	8.8	120.0	NaN	14.7	13.0	1011.6	0
2020-10-01 03:00:00	10.5	10.5	10.5	9.6	93.64	6.0	110.0	NaN	14.1	13.0	1011.1	-38
2020-10-01 04:00:00	10.3	10.3	10.3	9.4	94.15	8.6	127.0	NaN	14.0	0.0	1010.5	18
2020-10-01 05:00:00	10.2	10.2	10.2	9.4	94.54	11.0	111.0	NaN	14.4	0.0	1009.8	-9
2020-10-01 06:00:00	9.8	9.8	9.8	9.0	94.88	10.0	116.0	8.4	12.9	1.9	1009.3	0
2020-10-01 07:00:00	9.7	9.7	9.7	8.8	93.99	14.8	100.0	7.6	12.0	0.0	1008.7	0
2020-10-01 08:00:00	9.7	9.7	9.7	8.7	93.58	12.6	107.0	7.9	12.1	11.1	1008.4	-11
2020-10-01 09:00:00	10.7	10.7	10.7	9.3	91.16	13.5	109.0	NaN	12.1	0.0	1008.0	-4

	Minimum Temperature	Maximum Temperature	Temperature	Dew Point	Relative Humidity	Wind Speed	Wind Direction	Wind Chill	Snow Depth	Visibility	Cloud Cover	Sea Level Pressure	y
2022-10-09 15:00:00	15.0	15.0	15.0	7.1	59.04	12.3	200.0	NaN	NaN	49.0	NaN	1024.2	-7
2022-10-09 16:00:00	15.3	15.3	15.3	7.1	58.12	12.9	179.0	NaN	NaN	NaN	NaN	1023.5	0
2022-10-09 17:00:00	14.8	14.8	14.8	6.6	57.78	16.1	171.0	NaN	NaN	NaN	11.1	1022.8	0
2022-10-09 18:00:00	13.7	13.7	13.7	7.2	64.59	14.4	150.0	NaN	NaN	NaN	0.0	1022.1	-7
2022-10-09 19:00:00	11.3	11.3	11.3	7.2	75.66	12.0	139.0	NaN	NaN	28.0	NaN	1021.8	-6
2022-10-09 20:00:00	9.8	9.8	9.8	7.0	82.65	8.3	103.0	8.8	NaN	40.6	NaN	1021.6	6
2022-10-09 21:00:00	8.9	8.9	8.9	6.7	86.24	7.9	103.0	7.7	NaN	46.9	13.0	1021.2	0
2022-10-09 22:00:00	9.2	9.2	9.2	6.5	83.40	11.4	120.0	7.5	NaN	42.9	NaN	1020.8	0
2022-10-09 23:00:00	9.3	9.3	9.3	6.4	81.75	14.3	131.0	7.2	NaN	46.0	NaN	1020.4	0
2022-10-10 00:00:00	9.0	9.0	9.0	6.0	81.39	15.8	147.0	6.6	NaN	49.0	NaN	1020.0	0

Most frequently occurring

	Minimum Temperature	Maximum Temperature	Temperature	Dew Point	Relative Humidity	Wind Speed	Wind Direction	Wind Chill	Precipitation	Snow Depth	Visibility	Cloud Cover	Sea Level Pressure	y	# duplicates
34	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.00	NaN	NaN	NaN	NaN	0	22
0	-1.8	-1.8	-1.8	-2.8	92.77	1.8	143.0	NaN	0.00	NaN	24.1	0.0	1032.6	0	2
1	-1.3	-1.3	-1.3	-1.9	95.23	5.1	95.0	-3.1	0.00	NaN	8.3	0.0	1024.2	-12	2
2	1.2	1.2	1.2	-0.9	85.89	NaN	NaN	NaN	0.00	0.0	NaN	11.1	NaN	-42	2
3	3.5	3.5	3.5	3.1	97.42	8.0	249.0	1.4	0.00	0.0	3.9	NaN	1006.5	28	2
4	4.1	4.1	4.1	3.1	93.56	11.2	151.0	1.3	0.00	0.0	25.6	NaN	1018.6	0	2
5	5.3	5.3	5.3	4.8	96.73	11.9	271.0	2.6	0.06	NaN	6.7	NaN	1031.3	0	2
6	5.4	5.4	5.4	2.7	82.59	9.9	260.0	3.2	0.05	0.0	35.1	13.0	1016.0	-8	2
7	6.2	6.2	6.2	5.9	98.25	8.8	249.0	4.3	0.02	0.0	8.5	NaN	1026.2	30	2
8	6.6	6.6	6.6	1.3	68.99	2.0	82.0	NaN	0.00	NaN	14.9	0.0	1031.5	61	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

Duplicate rows

Most frequently occurring